Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
ReportingPeriodID (FK)(PK) | The unique system assigned identifier for a particular ReportingPeriod. | ID_PRD_RP | Identity | integer | ReportingPeriod(CA_PRD_RP) |
MerchandiseHierarchyGroupID (FK)(PK) | Unique system assigned identifier for a group or class of merchandise. | ID_MRHRC_GP | Identity | integer | RetailValuationLedgerAccount(LE_STKACT_RTL) |
RevenueCostCenterID (FK)(PK) | A unique retailer assigned identifier for an accounting budget, that owns merchandise and is used to track the financial performance of the retail enterprise. | ID_CTR_RVN_CST | Identity | integer | RetailValuationLedgerAccount(LE_STKACT_RTL) |
BeginningValueAmount | The monetary value of all Items owned by the MerchandisingCenter at the beginning of the historical ReportingPeriod | MO_VL_BGN | Money | decimal(16,5) | |
BeginningCumulativeMarkonAmount | The markon amount (initial markon) at the beginning of the historical ReportingPeriod. | MO_MKN_CM | Money | decimal(16,5) | |
BeginningCumulativeMarkonPercent | The markon percentage (initial markon) at the beginning of the historical ReportingPeriod. | PE_MKN_CM | Percent | decimal(7,4) | |
CumulativeGrossSalesRetailAmount | The cumulative gross sales for a specific ITEM since the beginning of the historical ReportingPeriod. The gross figure excludes returns. | TP_SLS_GS_CM | Money | decimal(16,5) | |
CumulativeReturnRetailAmount | The cumulative retail value of merchandise that is returned by customers to the RetailStore during the historical ReportingPeriod. | TP_RTN | Money | decimal(16,5) | |
CumulativeReceivedRetailAmount | The cumulative retail value of units received for a particular ITEM since the beginning of the historical ReportingPeriod. | TP_RCV | Money | decimal(16,5) | |
CumulativeTransferInRetailAmount | The cumulative retail value of merchandise transferred into the store from other stores or distribution centers during the historical ReportingPeriod. | MO_TSF_IN_CM | Money | decimal(16,5) | |
CumulativeTransferOutRetailAmount | The cumulative retail value of merchandise transferred from the store to another store or distribution center during the historical ReportingPeriod. | MO_TSF_OT_CM | Money | decimal(16,5) | |
CumulativeReturnToVendorRetailAmount | The cumulative retail value of merchandise returned to the vendor from the store during the historical ReportingPeriod. | TP_RTN_TO_VN | Money | decimal(16,5) | |
CumulativeAdjustmentRetailAmount | The cumulative retail value of inventory adjustments (overages and shortages) made to ItemInventory during the historical ReportingPeriod. | MO_ADJT_RT_CM | Money | decimal(16,5) | |
CumulativePermanentMarkdownAmount | The cumulative value of permanent markdowns taken against this item during the historical ReportingPeriod. | MO_MKD_PRN_CM | Money | decimal(16,5) | |
CumulativeTemporaryMarkdownAmount | The cumulative temporary or promotional markdown value taken against this item either as a price change or through the application of price derivation rules at the point of sale during the historical ReportingPeriod. | MO_MKD_TMP_CM | Money | decimal(16,5) | |
CumulativePermanentMarkupAmount | The cumulative value of permanent markups taken against this item during the historical ReportingPeriod. | MO_MKP_PRN_CM | Money | decimal(16,5) | |
CumulativeTemporaryMarkupAmount | The cumulative temporary or promotional markup value taken against this item either as a price change or through the application of price derivation rules at the point of sale, during the historical ReportingPeriod. | MO_MKP_TMP_CM | Money | decimal(16,5) | |
CumulativeDiscountAmount | Cumulative value of all discounts granted for the item during the historical ReportingPeriod. | MO_DSC_EM_CM | Money | decimal(16,5) | |
CumulativeDamagedItemDepreciationAmount | Cumulative retail value lost due to damage to stock during the historical ReportingPeriod. | MO_DPC_DM_CM_ITM | Money | decimal(16,5) | |
CumulativeOutOfDateItemDepreciationAmount | Cumulative retail value lost due to stock aging past its sell-by date during the historical ReportingPeriod. | MO_DPC_OT_OF_DT | Money | decimal(16,5) | |
EndingValueAmount | The monetary value of all Items owned by the MerchandisingCenter at the end of the historical ReportingPeriod. | MO_VL_END | Money | decimal(16,5) | |